package impl.repository;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;

import dao.AccessDatabase;
import domain.Customer;
import interfaces.repository.CustomerRepository;
import interfaces.repository.ProductApparelRepository;

public class StubCustomerRepositoryImpl implements CustomerRepository{

	@Override
	public Customer findByID(int id) {

		ArrayList<Customer> customers = new ArrayList<Customer>();
		Customer customer = null;
				
				
				try{

	        	AccessDatabase a = new AccessDatabase();
	            Connection con = a.conectar();
	            Statement st = con.createStatement();
	            ResultSet rs = st.executeQuery("SELECT * FROM productapparel where idProductApparel='"+id+"';");
	            
                
	             //customer = new Customer(name, password);
                
                 customers.add(customer);
           
                    
                con.close();
                return customer ;
            
            } catch (SQLException ex) {
                        Logger.getLogger(ProductApparelRepository.class.getName()).log(Level.SEVERE, null, ex);
        
                    }

		return null;
	}

	@Override
	public List<Customer> findByName(String name) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public boolean add(Customer customer) {
		// TODO Auto-generated method stub
		return false;
	}

	@Override
	public boolean edit(Customer before, Customer after) {
		// TODO Auto-generated method stub
		return false;
	}

	@Override
	public boolean delete(Customer customer) {
		// TODO Auto-generated method stub
		return false;
	}

}
